﻿-- North America
INSERT INTO [investment].[MIC] (Code, MIC.Name) VALUES ('XNYS', 'NEW YORK STOCK EXCHANGE, INC.');
INSERT INTO [investment].[MIC] (Code, MIC.Name) VALUES ('XNAS', 'NASDAQ - ALL MARKETS');
INSERT INTO [investment].[MIC] (Code, MIC.Name) VALUES ('ARCX', 'NYSE ARCA');
INSERT INTO [investment].[MIC] (Code, MIC.Name) VALUES ('XCNQ', 'CANADIAN NATIONAL STOCK EXCHANGE');
-- Europe
INSERT INTO [investment].[MIC] (Code, MIC.Name) VALUES ('XLON', 'LONDON STOCK EXCHANGE');
INSERT INTO [investment].[MIC] (Code, MIC.Name) VALUES ('XFRA', 'DEUTSCHE BOERSE AG');
INSERT INTO [investment].[MIC] (Code, MIC.Name) VALUES ('XMIL', 'BORSA ITALIANA S.P.A.');
INSERT INTO [investment].[MIC] (Code, MIC.Name) VALUES ('MISX', 'MOSCOW EXCHANGE');
-- Asia
INSERT INTO [investment].[MIC] (Code, MIC.Name) VALUES ('XBOM', 'BSE LTD');
INSERT INTO [investment].[MIC] (Code, MIC.Name) VALUES ('XNSE', 'NATIONAL STOCK EXCHANGE OF INDIA');
INSERT INTO [investment].[MIC] (Code, MIC.Name) VALUES ('XSHG', 'SHANGHAI STOCK EXCHANGE');
INSERT INTO [investment].[MIC] (Code, MIC.Name) VALUES ('XSHE', 'SHENZHEN STOCK EXCHANGE');
INSERT INTO [investment].[MIC] (Code, MIC.Name) VALUES ('XTAI', 'TAIWAN STOCK EXCHANGE');
INSERT INTO [investment].[MIC] (Code, MIC.Name) VALUES ('SGX', 'SINGAPORE EXCHANGE');

/*
The above exchanges are exchanges where we have real-time feed from Google Finance.
*/